<?php

/**
 * aboutus actions.
 *
 * @package    costabravasfr
 * @subpackage aboutus
 * @author     Your name here
 * @version    SVN: $Id: actions.class.php 12479 2008-10-31 10:54:40Z fabien $
 */
class costabravaActions extends sfActions
{
 /**
  * Executes index action
  *
  * @param sfRequest $request A request object
  */
  public function executeIndex(sfWebRequest $request)
  {
  
  }
  
  public function executeListVillages(sfWebRequest $request)
  {
	$q = Doctrine_Query::create()
	 ->select('v.*')
	  ->from('Villages v')
	  ->where('v.visible=?', 1);
	  
	 $this->logMessage("Num Villages ".$q->count(), "info");	 
	 
	$this->nbVillages = $q->count();
	$this->logMessage("Num Villages ".$this->nbVillages, "info");
    $this->pager = new sfDoctrinePager('Villages', sfConfig::get('app_max_locations_per_page'));
	$this->pager->setPage($request->getParameter('page', 1));
	$this->pager->setQuery($q);
	$this->pager->init();
  }
  
    public function executeShowVillage(sfWebRequest $request)
  {
	$this->village = $this->getRoute()->getObject();
	
	/*SELECT id, ( 3959 * acos( cos( radians(37) ) * cos( radians( lat ) ) * cos( radians( lng ) - radians(-122) ) + sin( radians(37) ) * sin( radians( lat ) ) ) ) AS distance 
FROM markers HAVING distance < 25 ORDER BY distance LIMIT 0 , 20;*/

	$q = Doctrine_Query::create()
	 ->select('v.*, ( 6371 * acos( cos( radians('.$this->village->getGeolatitud().') ) * cos( radians( geolatitud ) ) * cos( radians( geolongitud ) - radians('.$this->village->getGeolongitud().') ) + sin( radians('.$this->village->getGeolatitud().') ) * sin( radians( geolatitud ) ) ) ) AS distance')
	  ->from('Villages v')
	  ->where('v.nomvillage NOT LIKE ?', $this->village->getNomVillage())
	  ->having('distance < ?', sfConfig::get('app_village_nearest_dist'))
	  ->orderBy('distance')
	  ->limit(20);
	  
	  $this->nearest_list = $q->execute();

	
	$this->getResponse()->setTitle($this->village->getNomVillage()." - Guide Costa Brava");
	
	//Pics de Panoramio
	$URL_API_PANORAMIO = "http://www.panoramio.com/map/get_panoramas.php?order=popularity&set=full&from=0&to=".sfConfig::get('app_panoramio_max_photos')."&minx=".($this->village->getGeolongitud()-sfConfig::get('app_panoramio_lon_radio'))."&miny=".($this->village->getGeolatitud()-sfConfig::get('app_panoramio_lat_radio'))."&maxx=".($this->village->getGeolongitud()+sfConfig::get('app_panoramio_lon_radio'))."&maxy=".($this->village->getGeolatitud()+sfConfig::get('app_panoramio_lat_radio'))."&size=small";
	
	$contenido_url = $this->leer_contenido_completo($URL_API_PANORAMIO);

	$this->json_panoramio = json_decode($contenido_url);
	
	//google weather forecast
	$this->xml = simplexml_load_file(utf8_encode('http://www.google.com/ig/api?weather=').urlencode($this->village->getNomVillage()).utf8_encode('&hl=fr&oe=utf8'));
	$this->logMessage(utf8_encode('http://www.google.com/ig/api?weather=').urlencode($this->village->getNomVillage()).utf8_encode('&hl=fr&oe=utf8'));
	if($this->xml){
	$this->information = $this->xml->xpath("/xml_api_reply/weather/forecast_information");
	$this->current = $this->xml->xpath("/xml_api_reply/weather/current_conditions");
$this->forecast_list = $this->xml->xpath("/xml_api_reply/weather/forecast_conditions");
  }
  }
  
  private function leer_contenido_completo($url){
   $fichero_url = fopen ($url, "r");
   $texto = "";
   while ($trozo = fgets($fichero_url, 1024)){
      $texto .= $trozo;
   }
   return $texto;
}

private function xml2array($contents, $get_attributes=1, $priority = 'tag') { 
    if(!$contents) return array(); 

    if(!function_exists('xml_parser_create')) { 
        //print "'xml_parser_create()' function not found!"; 
        return array(); 
    } 

    //Get the XML parser of PHP - PHP must have this module for the parser to work
    $parser = xml_parser_create(''); 
    xml_parser_set_option($parser, XML_OPTION_TARGET_ENCODING, "UTF-8"); # http://minutillo.com/steve/weblog/2004/6/17/php-xml-and-character-encodings-a-tale-of-sadness-rage-and-data-loss 
    xml_parser_set_option($parser, XML_OPTION_CASE_FOLDING, 0); 
    xml_parser_set_option($parser, XML_OPTION_SKIP_WHITE, 1); 
    xml_parse_into_struct($parser, trim($contents), $xml_values); 
    xml_parser_free($parser); 

    if(!$xml_values) return;//Hmm... 

    //Initializations 
    $xml_array = array(); 
    $parents = array(); 
    $opened_tags = array(); 
    $arr = array(); 

    $current = &$xml_array; //Refference 

    //Go through the tags. 
    $repeated_tag_index = array();//Multiple tags with same name will be turned into an array
    foreach($xml_values as $data) { 
        unset($attributes,$value);//Remove existing values, or there will be trouble

        //This command will extract these variables into the foreach scope 
        // tag(string), type(string), level(int), attributes(array). 
        extract($data);//We could use the array by itself, but this cooler. 

        $result = array(); 
        $attributes_data = array(); 
         
        if(isset($value)) { 
            if($priority == 'tag') $result = $value; 
            else $result['value'] = $value; //Put the value in a assoc array if we are in the 'Attribute' mode
        } 

        //Set the attributes too. 
        if(isset($attributes) and $get_attributes) { 
            foreach($attributes as $attr => $val) { 
                if($priority == 'tag') $attributes_data[$attr] = $val; 
                else $result['attr'][$attr] = $val; //Set all the attributes in a array called 'attr'
            } 
        } 

        //See tag status and do the needed. 
        if($type == "open") {//The starting of the tag '<tag>' 
            $parent[$level-1] = &$current; 
            if(!is_array($current) or (!in_array($tag, array_keys($current)))) { //Insert New tag
                $current[$tag] = $result; 
                if($attributes_data) $current[$tag. '_attr'] = $attributes_data; 
                $repeated_tag_index[$tag.'_'.$level] = 1; 

                $current = &$current[$tag]; 

            } else { //There was another element with the same tag name 

                if(isset($current[$tag][0])) {//If there is a 0th element it is already an array
                    $current[$tag][$repeated_tag_index[$tag.'_'.$level]] = $result;
                    $repeated_tag_index[$tag.'_'.$level]++; 
                } else {//This section will make the value an array if multiple tags with the same name appear together
                    $current[$tag] = array($current[$tag],$result);//This will combine the existing item and the new item together to make an array
                    $repeated_tag_index[$tag.'_'.$level] = 2; 
                     
                    if(isset($current[$tag.'_attr'])) { //The attribute of the last(0th) tag must be moved as well
                        $current[$tag]['0_attr'] = $current[$tag.'_attr']; 
                        unset($current[$tag.'_attr']); 
                    } 

                } 
                $last_item_index = $repeated_tag_index[$tag.'_'.$level]-1; 
                $current = &$current[$tag][$last_item_index]; 
            } 

        } elseif($type == "complete") { //Tags that ends in 1 line '<tag />' 
            //See if the key is already taken. 
            if(!isset($current[$tag])) { //New Key 
                $current[$tag] = $result; 
                $repeated_tag_index[$tag.'_'.$level] = 1; 
                if($priority == 'tag' and $attributes_data) $current[$tag. '_attr'] = $attributes_data;

            } else { //If taken, put all things inside a list(array) 
                if(isset($current[$tag][0]) and is_array($current[$tag])) {//If it is already an array...

                    // ...push the new element into that array. 
                    $current[$tag][$repeated_tag_index[$tag.'_'.$level]] = $result;
                     
                    if($priority == 'tag' and $get_attributes and $attributes_data) {
                        $current[$tag][$repeated_tag_index[$tag.'_'.$level] . '_attr'] = $attributes_data;
                    } 
                    $repeated_tag_index[$tag.'_'.$level]++; 

                } else { //If it is not an array... 
                    $current[$tag] = array($current[$tag],$result); //...Make it an array using using the existing value and the new value
                    $repeated_tag_index[$tag.'_'.$level] = 1; 
                    if($priority == 'tag' and $get_attributes) { 
                        if(isset($current[$tag.'_attr'])) { //The attribute of the last(0th) tag must be moved as well
                             
                            $current[$tag]['0_attr'] = $current[$tag.'_attr']; 
                            unset($current[$tag.'_attr']); 
                        } 
                         
                        if($attributes_data) { 
                            $current[$tag][$repeated_tag_index[$tag.'_'.$level] . '_attr'] = $attributes_data;
                        } 
                    } 
                    $repeated_tag_index[$tag.'_'.$level]++; //0 and 1 index is already taken
                } 
            } 

        } elseif($type == 'close') { //End of tag '</tag>' 
            $current = &$parent[$level-1]; 
        } 
    } 
     
    return($xml_array); 
}  
  
}
